Released on: October 31, 2008, 5:15 pm

Press Release Author: Alba Spectrum LLC

Industry: Computers

Press Release Summary: Microsoft Dynamics GP Great Plains ERP was designed in
earlier 1990thwith new Shell Great Plains Dexterity. Dex was in turn programmed in
C++ to resolve operating system and Database platform dependency

Press Release Body: Microsoft Dynamics GP Great Plains ERP was designed in earlier
1990thwith new Shell Great Plains Dexterity. Dex was in turn programmed in C++ to
resolve operating system and Database platform dependency. However C programming
language was in time and probably now, especially when you are trying to use
platform independent functions - not perfect in working with new Windows drivers:
PDF printing, pictures formats, working with Unicode and International ASCII
collations, web publishing, etc. In this small publication we would like to review
long text attachments, which you can do in Dynamics GP - comments:

1. OLE and Pictures. Great Plains was initially supporting and currently supports
these technologies, however OLE compliant applications and pictures are stored in
the files, and not in SQL database

2. Text attachments or Notes. Comments are stored in MS SQL Server company
database. Dynamics GP supports only four lines of notes, plus you should be aware
that they are stored in the following table: SY04200 - comment master. Here you can
assign comment id to each specific comment. However when you are attaching comment
to, let's say, SOP invoice line - you are copying its contents to the comment
instantiation table - SOP10202 in our example. However on this instantiation level
GP actually splits comments text into four comment lines: COMMENT_1, 2, 3 and 4 -
system makes a judgment and decides if the line should be split

3. Updating comments on the existing documents. If you have a need to update
comment on Sales Invoice line level you will have to produce the algorithm from
SY04200 comment master table, where you will be splitting comment text field into
four comment lines. These four comment lines will be used by GP workstation to
print popular reports, such as SOP Invoice Blank form

4. eConnect eCommerce programming. Here you have encrypted stored procedures, which
you can call from MS Visual Studio C# or VB .Net project, however comment
restrictions apply and you still have to deal with four comment lines. If you
decide to introduce customization, then you can potentially break trough


Web Site: http://www.albaspectrum.com

Contact Details: Andrew Karasev, Alba Spectrum LLC, help@albaspectrum.com,
http://www.albaspectrum.com, 1-866-528-0577 , Great Plains, VAR, Partner and
Reseller in Illinois, Georgia, South Carolina, California, Texas. Please visit our
info portal Pegas Planet: http://www.pegasplanet.com Local Service in Chicago,
Atlanta, San Diego, Los Angeles, Orange County, Houston. We also have Dexterity
Software Development Factory and SB1 Technical Support Call Center, serving USA
country side businesses and internationally: Canada, Brazil. Illinois practice:
Naperville, Aurora, Plainfield, Marseilles, Ottawa, DeKalb, Springfield, Oakbrook,
Glenn Ellyn, Wheaton, Bolingbrook, Romeoville, Lisle, Melrose Park, Brookfield. San
Diego and LA practice: Rancho Bernardo, Oceanside, Poway, Long Beach, Irvine,
Mission Viejo, San Marcos, Carlsbad, La Jolla, Escondido. Houston Practice: Dallas,
Galveston, Sugar Land, Pearland, Katy, Pasadena, Rosenberg, League City, Galena Park